Tabela Invoice

Definicja tabeli Invoice

Name

Invoice

Code

Invoice

Comment

 


Lista kolumn tabeli Invoice

Name

Code

InvoiceID

InvoiceID

ContractID

ContractID

InvoiceDataID

InvoiceDataID

InvoiceTypeID

InvoiceTypeID

PaymentTypeID

PaymentTypeID

AccountTemplateID

AccountTemplateID

Active

Active

Comments

Comments

DateValue

DateValue

DaysCount

DaysCount

PaymentDeadline

PaymentDeadline

SellDate

SellDate

Value

Value

InvoiceNo

InvoiceNo

PrintDate

PrintDate

CurrentInvoiceStatusID

CurrentInvoiceStatusID

ServiceSaleDate

ServiceSaleDate

Posted

Posted


Kolumna InvoiceID tabeli Invoice

Definicja kolumny InvoiceID tabeli Invoice

Name

InvoiceID

Code

InvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli Invoice

Definicja kolumny ContractID tabeli Invoice

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceDataID tabeli Invoice

Definicja kolumny InvoiceDataID tabeli Invoice

Name

InvoiceDataID

Code

InvoiceDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceTypeID tabeli Invoice

Definicja kolumny InvoiceTypeID tabeli Invoice

Name

InvoiceTypeID

Code

InvoiceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTypeID tabeli Invoice

Definicja kolumny PaymentTypeID tabeli Invoice

Name

PaymentTypeID

Code

PaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountTemplateID tabeli Invoice

Definicja kolumny AccountTemplateID tabeli Invoice

Name

AccountTemplateID

Code

AccountTemplateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Invoice

Definicja kolumny Active tabeli Invoice

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Comments tabeli Invoice

Definicja kolumny Comments tabeli Invoice

Name

Comments

Code

Comments

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna DateValue tabeli Invoice

Definicja kolumny DateValue tabeli Invoice

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DaysCount tabeli Invoice

Definicja kolumny DaysCount tabeli Invoice

Name

DaysCount

Code

DaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentDeadline tabeli Invoice

Definicja kolumny PaymentDeadline tabeli Invoice

Name

PaymentDeadline

Code

PaymentDeadline

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SellDate tabeli Invoice

Definicja kolumny SellDate tabeli Invoice

Name

SellDate

Code

SellDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Value tabeli Invoice

Definicja kolumny Value tabeli Invoice

Name

Value

Code

Value

Data Type

NUMBER(12,2)

Mandatory

No

Comment

 


Kolumna InvoiceNo tabeli Invoice

Definicja kolumny InvoiceNo tabeli Invoice

Name

InvoiceNo

Code

InvoiceNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna PrintDate tabeli Invoice

Definicja kolumny PrintDate tabeli Invoice

Name

PrintDate

Code

PrintDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CurrentInvoiceStatusID tabeli Invoice

Definicja kolumny CurrentInvoiceStatusID tabeli Invoice

Name

CurrentInvoiceStatusID

Code

CurrentInvoiceStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServiceSaleDate tabeli Invoice

Definicja kolumny ServiceSaleDate tabeli Invoice

Name

ServiceSaleDate

Code

ServiceSaleDate

Data Type

DATE

Mandatory

No

Comment

Kolumna opisuje date sprzedazy


Kolumna Posted tabeli Invoice

Definicja kolumny Posted tabeli Invoice

Name

Posted

Code

Posted

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy faktura zaksiegowana w FK


Lista kluczy tabeli Invoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Invoice

Definicja klucza Identifier_1 tabeli Invoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment